Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

ORACLE and OpenEdge objects and terminology

ORACLE and OpenEdge databases share the structural elements common to relational databases, but each system has its own elements. These structural elements are called schema objects in ORACLE and database objects in OpenEdge. Schema objects or database objects are components of the database’s logical structure. The two database management systems have different terminology for referring to these objects, as shown in Table 2–1.

Table 2–1: ORACLE and OpenEdge objects

ORACLE schema object	OpenEdge equivalent
Table.	Table.
Column.	Field.
Row.	Record.
Index.	Index.
Sequences.	Sequences.
Integrity constraint1.	Validation expression.
No equivalent.	Validation message.
Trigger.	Trigger.
Stored procedures.	Stored procedures (SQL Engine).
View.	View (SQL Engine).
Clusters.	No equivalent.
ORACLE Object methods.	No equivalent.
Synonyms.	Synonyms (SQL Engine).

1The ORACLE Integrity constraint enforces data integrity and business rules. However, unlike the Progress 4GL validation expression, you cannot include code in the integrity constraint. You choose one of the following checks: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK.